﻿--------sua lai store procedure sp_Thanh_GetSellingRateList_2, sap xep theo rank
-- =============================================
-- Author:		Hong Thanh
-- Create date: 06/1/2014
-- Description:	Lay ra cac thong tin Selling Rate cua file hien thoi, co thi lay, khong thi thoi
-- =============================================
ALTER PROCEDURE [dbo].[sp_Thanh_GetSellingRateList_2] 
	@idHBL int
AS
BEGIN
	select f.FeeName, s.UnitPrice, s.Quantity, s.Price, c.Code, s.Description, s.ID_SellingFee
	from tblFee as f, tblCurrency as c, tblSellingFee as s
	where f.ID_Fee = s.ID_Fee and s.ID_HBL = @idHBL and c.ID_Currency = s.ID_Currency
	order by f.[Rank]
END